Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	29500
Missing cells	72214
Missing cells (%)	12.2%
Duplicate rows	107
Duplicate rows (%)	0.4%
Total size in memory	4.5 MiB
Average record size in memory	160.0 B

Variable types

Categorical	4
Numeric	14
Boolean	2

Warnings

Dataset has 107 (0.4%) duplicate rows	Duplicates
`weekid` has a high cardinality: 3262 distinct values	High cardinality
`song` has a high cardinality: 24359 distinct values	High cardinality
`performer` has a high cardinality: 10059 distinct values	High cardinality
`week_position` is highly correlated with `peak_position`	High correlation
`weeks_on_chart` is highly correlated with `peak_position`	High correlation
`peak_position` is highly correlated with `week_position` and 1 other fields	High correlation
`energy` is highly correlated with `loudness` and 1 other fields	High correlation
`loudness` is highly correlated with `energy`	High correlation
`acousticness` is highly correlated with `energy`	High correlation
`weeks_on_chart` is highly correlated with `peak_position`	High correlation
`peak_position` is highly correlated with `weeks_on_chart`	High correlation
`energy` is highly correlated with `loudness` and 1 other fields	High correlation
`loudness` is highly correlated with `energy`	High correlation
`acousticness` is highly correlated with `energy`	High correlation
`weeks_on_chart` is highly correlated with `peak_position`	High correlation
`peak_position` is highly correlated with `weeks_on_chart`	High correlation
`weeks_on_chart` is highly correlated with `peak_position`	High correlation
`peak_position` is highly correlated with `weeks_on_chart` and 1 other fields	High correlation
`acousticness` is highly correlated with `energy`	High correlation
`energy` is highly correlated with `acousticness` and 1 other fields	High correlation
`speechiness` is highly correlated with `spotify_track_explicit`	High correlation
`time_signature` is highly correlated with `tempo` and 1 other fields	High correlation
`spotify_track_explicit` is highly correlated with `speechiness`	High correlation
`tempo` is highly correlated with `time_signature` and 1 other fields	High correlation
`week_position` is highly correlated with `peak_position`	High correlation
`loudness` is highly correlated with `energy`	High correlation
`danceability` is highly correlated with `time_signature` and 1 other fields	High correlation
`spotify_track_duration_ms` has 5105 (17.3%) missing values	Missing
`spotify_track_explicit` has 5105 (17.3%) missing values	Missing
`danceability` has 5167 (17.5%) missing values	Missing
`energy` has 5167 (17.5%) missing values	Missing
`key` has 5167 (17.5%) missing values	Missing
`loudness` has 5167 (17.5%) missing values	Missing
`mode` has 5167 (17.5%) missing values	Missing
`speechiness` has 5167 (17.5%) missing values	Missing
`acousticness` has 5167 (17.5%) missing values	Missing
`instrumentalness` has 5167 (17.5%) missing values	Missing
`liveness` has 5167 (17.5%) missing values	Missing
`valence` has 5167 (17.5%) missing values	Missing
`tempo` has 5167 (17.5%) missing values	Missing
`time_signature` has 5167 (17.5%) missing values	Missing
`song` is uniformly distributed	Uniform
`key` has 3035 (10.3%) zeros	Zeros
`instrumentalness` has 10079 (34.2%) zeros	Zeros

Reproduction

Analysis started	2021-08-15 21:12:17.214179
Analysis finished	2021-08-15 21:12:48.032212
Duration	30.82 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

weekid
Categorical

HIGH CARDINALITY

Distinct	3262
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	230.6 KiB

2021-05-29	99
1998-11-28	54
2021-01-02	38
2019-08-24	29
2021-01-09	27
Other values (3257)	29253

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	295000
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	2009-12-26
2nd row	2014-01-04
3rd row	2017-07-29
4th row	2018-12-22
5th row	2019-06-01

Common Values

Value	Count	Frequency (%)
2021-05-29	99	0.3%
1998-11-28	54	0.2%
2021-01-02	38	0.1%
2019-08-24	29	0.1%
2021-01-09	27	0.1%
2020-03-07	24	0.1%
1968-08-24	23	0.1%
2020-03-14	23	0.1%
1966-03-12	23	0.1%
2021-05-22	23	0.1%
Other values (3252)	29137	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-05-29	99	0.3%
1998-11-28	54	0.2%
2021-01-02	38	0.1%
2019-08-24	29	0.1%
2021-01-09	27	0.1%
2020-03-07	24	0.1%
1968-08-24	23	0.1%
2020-03-14	23	0.1%
1966-03-12	23	0.1%
2021-05-22	23	0.1%
Other values (3252)	29137	98.8%

Most occurring characters

Value	Count	Frequency (%)
-	59000	20.0%
1	53501	18.1%
0	52227	17.7%
9	32728	11.1%
2	30028	10.2%
6	14937	5.1%
7	13289	4.5%
8	12638	4.3%
3	9582	3.2%
5	9098	3.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	236000	80.0%
Dash Punctuation	59000	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	53501	22.7%
0	52227	22.1%
9	32728	13.9%
2	30028	12.7%
6	14937	6.3%
7	13289	5.6%
8	12638	5.4%
3	9582	4.1%
5	9098	3.9%
4	7972	3.4%

Dash Punctuation

Value	Count	Frequency (%)
-	59000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	295000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	59000	20.0%
1	53501	18.1%
0	52227	17.7%
9	32728	11.1%
2	30028	10.2%
6	14937	5.1%
7	13289	4.5%
8	12638	4.3%
3	9582	3.2%
5	9098	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	295000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	59000	20.0%
1	53501	18.1%
0	52227	17.7%
9	32728	11.1%
2	30028	10.2%
6	14937	5.1%
7	13289	4.5%
8	12638	4.3%
3	9582	3.2%
5	9098	3.1%

week_position
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	100
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.5679322

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	1
5-th percentile	37
Q1	59
median	85
Q3	95
95-th percentile	100
Maximum	100
Range	99
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	21.71969083
Coefficient of variation (CV)	0.2836656314
Kurtosis	-0.7435583955
Mean	76.5679322
Median Absolute Deviation (MAD)	13
Skewness	-0.7243040582
Sum	2258754
Variance	471.7449698
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	1715	5.8%
99	1538	5.2%
98	1418	4.8%
97	1387	4.7%
96	1187	4.0%
94	1081	3.7%
95	1054	3.6%
93	938	3.2%
92	851	2.9%
91	826	2.8%
Other values (90)	17505	59.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	2	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	2	< 0.1%
9	6	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
100	1715	5.8%
99	1538	5.2%
98	1418	4.8%
97	1387	4.7%
96	1187	4.0%
95	1054	3.6%
94	1081	3.7%
93	938	3.2%
92	851	2.9%
91	826	2.8%

song
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	24359
Distinct (%)	82.6%
Missing	0
Missing (%)	0.0%
Memory size	230.6 KiB

Hold On	17
Forever	14
Stay	14
You	14
Angel	14
Other values (24354)	29427

Length

Max length	75
Median length	15
Mean length	16.55481356
Min length	1

Characters and Unicode

Total characters	488367
Distinct characters	96
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21233 ?
Unique (%)	72.0%

Sample

1st row	My Life Would Suck Without You
2nd row	I Have Nothing
3rd row	Family Feud
4th row	I Don't Let Go
5th row	I Think

Common Values

Value	Count	Frequency (%)
Hold On	17	0.1%
Forever	14	< 0.1%
Stay	14	< 0.1%
You	14	< 0.1%
Angel	14	< 0.1%
Happy	13	< 0.1%
Without You	12	< 0.1%
Smile	12	< 0.1%
Runaway	12	< 0.1%
I Need You	11	< 0.1%
Other values (24349)	29367	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	3867	3.9%
you	3088	3.1%
i	2354	2.4%
love	2242	2.3%
me	1963	2.0%
a	1766	1.8%
to	1617	1.6%
my	1387	1.4%
of	1373	1.4%
in	1282	1.3%
Other values (9564)	77824	78.8%

Most occurring characters

Value	Count	Frequency (%)
	69263	14.2%
e	45868	9.4%
o	33707	6.9%
n	24944	5.1%
a	23724	4.9%
t	21130	4.3%
i	20280	4.2%
r	19551	4.0%
l	14592	3.0%
h	14083	2.9%
Other values (86)	201225	41.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	304919	62.4%
Uppercase Letter	99278	20.3%
Space Separator	69263	14.2%
Other Punctuation	8860	1.8%
Open Punctuation	2094	0.4%
Close Punctuation	2092	0.4%
Decimal Number	1153	0.2%
Dash Punctuation	673	0.1%
Currency Symbol	18	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	45868	15.0%
o	33707	11.1%
n	24944	8.2%
a	23724	7.8%
t	21130	6.9%
i	20280	6.7%
r	19551	6.4%
l	14592	4.8%
h	14083	4.6%
s	13367	4.4%
Other values (23)	73673	24.2%

Uppercase Letter

Value	Count	Frequency (%)
T	10953	11.0%
I	7541	7.6%
M	7223	7.3%
S	7092	7.1%
L	6885	6.9%
A	6264	6.3%
W	5702	5.7%
B	5687	5.7%
Y	4814	4.8%
O	4522	4.6%
Other values (17)	32595	32.8%

Other Punctuation

Value	Count	Frequency (%)
'	5491	62.0%
,	913	10.3%
.	862	9.7%
"	558	6.3%
/	275	3.1%
!	211	2.4%
?	206	2.3%
&	170	1.9%
*	128	1.4%
#	19	0.2%
Other values (5)	27	0.3%

Decimal Number

Value	Count	Frequency (%)
1	288	25.0%
2	187	16.2%
0	152	13.2%
9	109	9.5%
4	105	9.1%
3	79	6.9%
5	74	6.4%
7	58	5.0%
6	56	4.9%
8	45	3.9%

Math Symbol

Value	Count	Frequency (%)
+	12	80.0%
=	2	13.3%
>	1	6.7%

Open Punctuation

Value	Count	Frequency (%)
(	2087	99.7%
[	7	0.3%

Close Punctuation

Value	Count	Frequency (%)
)	2085	99.7%
]	7	0.3%

Space Separator

Value	Count	Frequency (%)
	69263	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	673	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	18	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	404197	82.8%
Common	84170	17.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	45868	11.3%
o	33707	8.3%
n	24944	6.2%
a	23724	5.9%
t	21130	5.2%
i	20280	5.0%
r	19551	4.8%
l	14592	3.6%
h	14083	3.5%
s	13367	3.3%
Other values (50)	172951	42.8%

Common

Value	Count	Frequency (%)
	69263	82.3%
'	5491	6.5%
(	2087	2.5%
)	2085	2.5%
,	913	1.1%
.	862	1.0%
-	673	0.8%
"	558	0.7%
1	288	0.3%
/	275	0.3%
Other values (26)	1675	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	488350	> 99.9%
Latin 1 Sup	17	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	69263	14.2%
e	45868	9.4%
o	33707	6.9%
n	24944	5.1%
a	23724	4.9%
t	21130	4.3%
i	20280	4.2%
r	19551	4.0%
l	14592	3.0%
h	14083	2.9%
Other values (77)	201208	41.2%

Latin 1 Sup

Value	Count	Frequency (%)
é	5	29.4%
á	3	17.6%
ó	2	11.8%
ñ	2	11.8%
¿	1	5.9%
ò	1	5.9%
à	1	5.9%
ö	1	5.9%
Ó	1	5.9%

performer
Categorical

HIGH CARDINALITY

Distinct	10059
Distinct (%)	34.1%
Missing	0
Missing (%)	0.0%
Memory size	230.6 KiB

Glee Cast	183
Taylor Swift	119
Drake	99
The Beatles	65
Aretha Franklin	64
Other values (10054)	28970

Length

Max length	113
Median length	12
Mean length	15.06430508
Min length	1

Characters and Unicode

Total characters	444397
Distinct characters	81
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6453 ?
Unique (%)	21.9%

Sample

1st row	Glee Cast
2nd row	Tessanne Chin
3rd row	JAY-Z Featuring Beyonce
4th row	XXXTENTACION
5th row	Tyler, The Creator

Common Values

Value	Count	Frequency (%)
Glee Cast	183	0.6%
Taylor Swift	119	0.4%
Drake	99	0.3%
The Beatles	65	0.2%
Aretha Franklin	64	0.2%
Elton John	58	0.2%
The Rolling Stones	57	0.2%
The Beach Boys	54	0.2%
Stevie Wonder	54	0.2%
Madonna	53	0.2%
Other values (10049)	28694	97.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	4965	6.5%
featuring	2540	3.3%
	2407	3.2%
and	929	1.2%
lil	507	0.7%
john	369	0.5%
bobby	361	0.5%
brown	336	0.4%
band	328	0.4%
with	305	0.4%
Other values (8042)	62944	82.8%

Most occurring characters

Value	Count	Frequency (%)
	46491	10.5%
e	42641	9.6%
a	32103	7.2%
n	28531	6.4%
i	26042	5.9%
r	25164	5.7%
o	22022	5.0%
l	17723	4.0%
t	17594	4.0%
s	16994	3.8%
Other values (71)	169092	38.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	313295	70.5%
Uppercase Letter	77135	17.4%
Space Separator	46491	10.5%
Other Punctuation	5351	1.2%
Decimal Number	1122	0.3%
Dash Punctuation	644	0.1%
Open Punctuation	109	< 0.1%
Close Punctuation	109	< 0.1%
Currency Symbol	89	< 0.1%
Math Symbol	51	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	8442	10.9%
B	6761	8.8%
S	5789	7.5%
C	5452	7.1%
F	4928	6.4%
M	4769	6.2%
J	4633	6.0%
D	4290	5.6%
A	3683	4.8%
R	3568	4.6%
Other values (16)	24820	32.2%

Lowercase Letter

Value	Count	Frequency (%)
e	42641	13.6%
a	32103	10.2%
n	28531	9.1%
i	26042	8.3%
r	25164	8.0%
o	22022	7.0%
l	17723	5.7%
t	17594	5.6%
s	16994	5.4%
h	13745	4.4%
Other values (16)	70736	22.6%

Other Punctuation

Value	Count	Frequency (%)
&	2360	44.1%
.	1603	30.0%
,	531	9.9%
'	476	8.9%
"	185	3.5%
!	96	1.8%
/	75	1.4%
?	11	0.2%
*	10	0.2%
:	4	0.1%

Decimal Number

Value	Count	Frequency (%)
2	243	21.7%
0	181	16.1%
5	173	15.4%
1	162	14.4%
4	102	9.1%
3	79	7.0%
6	67	6.0%
9	56	5.0%
7	31	2.8%
8	28	2.5%

Open Punctuation

Value	Count	Frequency (%)
(	106	97.2%
[	3	2.8%

Close Punctuation

Value	Count	Frequency (%)
)	106	97.2%
]	3	2.8%

Space Separator

Value	Count	Frequency (%)
	46491	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	644	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	89	100.0%

Math Symbol

Value	Count	Frequency (%)
+	51	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	390430	87.9%
Common	53967	12.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	42641	10.9%
a	32103	8.2%
n	28531	7.3%
i	26042	6.7%
r	25164	6.4%
o	22022	5.6%
l	17723	4.5%
t	17594	4.5%
s	16994	4.4%
h	13745	3.5%
Other values (42)	147871	37.9%

Common

Value	Count	Frequency (%)
	46491	86.1%
&	2360	4.4%
.	1603	3.0%
-	644	1.2%
,	531	1.0%
'	476	0.9%
2	243	0.5%
"	185	0.3%
0	181	0.3%
5	173	0.3%
Other values (19)	1080	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	444397	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	46491	10.5%
e	42641	9.6%
a	32103	7.2%
n	28531	6.4%
i	26042	5.9%
r	25164	5.7%
o	22022	5.0%
l	17723	4.0%
t	17594	4.0%
s	16994	3.8%
Other values (71)	169092	38.0%

weeks_on_chart
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	69
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.20318644

Minimum	1
Maximum	87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	5
median	10
Q3	16
95-th percentile	25
Maximum	87
Range	86
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.337059611
Coefficient of variation (CV)	0.7441686037
Kurtosis	3.61344583
Mean	11.20318644
Median Absolute Deviation (MAD)	6
Skewness	1.340103597
Sum	330494
Variance	69.50656295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2520	8.5%
20	2354	8.0%
2	1670	5.7%
8	1594	5.4%
7	1580	5.4%
6	1575	5.3%
5	1439	4.9%
9	1413	4.8%
3	1413	4.8%
4	1394	4.7%
Other values (59)	12548	42.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2520	8.5%
2	1670	5.7%
3	1413	4.8%
4	1394	4.7%
5	1439	4.9%
6	1575	5.3%
7	1580	5.4%
8	1594	5.4%
9	1413	4.8%
10	1279	4.3%

Value	Count	Frequency (%)
87	1	< 0.1%
79	1	< 0.1%
76	2	< 0.1%
69	1	< 0.1%
68	2	< 0.1%
65	2	< 0.1%
64	1	< 0.1%
62	3	< 0.1%
61	2	< 0.1%
60	2	< 0.1%

peak_position
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	100
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.40844068

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	19
median	47
Q3	75
95-th percentile	95
Maximum	100
Range	99
Interquartile range (IQR)	56

Descriptive statistics

Standard deviation	30.93113972
Coefficient of variation (CV)	0.6524395082
Kurtosis	-1.302364969
Mean	47.40844068
Median Absolute Deviation (MAD)	28
Skewness	0.06412696724
Sum	1398549
Variance	956.7354045
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1107	3.8%
3	504	1.7%
2	499	1.7%
4	445	1.5%
5	426	1.4%
7	408	1.4%
6	403	1.4%
8	389	1.3%
91	384	1.3%
10	381	1.3%
Other values (90)	24554	83.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1107	3.8%
2	499	1.7%
3	504	1.7%
4	445	1.5%
5	426	1.4%
6	403	1.4%
7	408	1.4%
8	389	1.3%
9	375	1.3%
10	381	1.3%

Value	Count	Frequency (%)
100	247	0.8%
99	282	1.0%
98	302	1.0%
97	329	1.1%
96	304	1.0%
95	302	1.0%
94	333	1.1%
93	314	1.1%
92	353	1.2%
91	384	1.3%

spotify_track_duration_ms
Real number (ℝ_≥0)

MISSING

Distinct	13983
Distinct (%)	57.3%
Missing	5105
Missing (%)	17.3%
Infinite	0
Infinite (%)	0.0%
Mean	220681.1945

Minimum	29688
Maximum	3079157
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	29688
5-th percentile	135658.2
Q1	175053
median	214850
Q3	253253
95-th percentile	327746.3
Maximum	3079157
Range	3049469
Interquartile range (IQR)	78200

Descriptive statistics

Standard deviation	67745.14511
Coefficient of variation (CV)	0.3069819576
Kurtosis	146.2738291
Mean	220681.1945
Median Absolute Deviation (MAD)	39150
Skewness	4.973578707
Sum	5383517741
Variance	4589404686
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
205733	10	< 0.1%
160000	10	< 0.1%
196000	9	< 0.1%
280000	9	< 0.1%
251333	9	< 0.1%
161533	9	< 0.1%
231400	9	< 0.1%
227266	9	< 0.1%
229466	9	< 0.1%
159666	8	< 0.1%
Other values (13973)	24304	82.4%
(Missing)	5105	17.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
29688	1	< 0.1%
37013	1	< 0.1%
46253	1	< 0.1%
48000	1	< 0.1%
49292	1	< 0.1%
61306	1	< 0.1%
67749	1	< 0.1%
69000	1	< 0.1%
70556	1	< 0.1%
71306	1	< 0.1%

Value	Count	Frequency (%)
3079157	1	< 0.1%
1561133	1	< 0.1%
1367093	1	< 0.1%
1124153	1	< 0.1%
1008533	1	< 0.1%
992160	1	< 0.1%
941360	1	< 0.1%
901000	1	< 0.1%
869333	1	< 0.1%
834866	1	< 0.1%

spotify_track_explicit
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	5105
Missing (%)	17.3%
Memory size	230.6 KiB

False	21447
True	2948
(Missing)	5105

Common Values
Chart

Value	Count	Frequency (%)
False	21447	72.7%
True	2948	10.0%
(Missing)	5105	17.3%

danceability
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	837
Distinct (%)	3.4%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.5999513418

Minimum	0
Maximum	0.988
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.329
Q1	0.499
median	0.608
Q3	0.708
95-th percentile	0.845
Maximum	0.988
Range	0.988
Interquartile range (IQR)	0.209

Descriptive statistics

Standard deviation	0.1531327566
Coefficient of variation (CV)	0.2552419604
Kurtosis	-0.2349437672
Mean	0.5999513418
Median Absolute Deviation (MAD)	0.104
Skewness	-0.2366541587
Sum	14598.616
Variance	0.02344964115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.637	86	0.3%
0.674	82	0.3%
0.628	82	0.3%
0.652	81	0.3%
0.66	80	0.3%
0.61	79	0.3%
0.602	79	0.3%
0.551	77	0.3%
0.589	76	0.3%
0.623	74	0.3%
Other values (827)	23537	79.8%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.103	1	< 0.1%
0.105	1	< 0.1%
0.107	1	< 0.1%
0.11	1	< 0.1%
0.111	1	< 0.1%
0.113	2	< 0.1%
0.12	1	< 0.1%
0.123	1	< 0.1%
0.126	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.986	1	< 0.1%
0.981	1	< 0.1%
0.98	2	< 0.1%
0.978	2	< 0.1%
0.974	6	< 0.1%
0.973	2	< 0.1%
0.972	1	< 0.1%
0.971	1	< 0.1%
0.968	1	< 0.1%

energy
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	985
Distinct (%)	4.0%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.6181075774

Minimum	0.000581
Maximum	0.997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0.000581
5-th percentile	0.2686
Q1	0.476
median	0.634
Q3	0.778
95-th percentile	0.9134
Maximum	0.997
Range	0.996419
Interquartile range (IQR)	0.302

Descriptive statistics

Standard deviation	0.1990736472
Coefficient of variation (CV)	0.3220695789
Kurtosis	-0.5962893818
Mean	0.6181075774
Median Absolute Deviation (MAD)	0.15
Skewness	-0.3293440475
Sum	15040.41168
Variance	0.039630317
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.73	62	0.2%
0.671	58	0.2%
0.727	58	0.2%
0.72	58	0.2%
0.743	57	0.2%
0.804	57	0.2%
0.641	56	0.2%
0.61	56	0.2%
0.623	54	0.2%
0.703	54	0.2%
Other values (975)	23763	80.6%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.000581	1	< 0.1%
0.0181	1	< 0.1%
0.0201	1	< 0.1%
0.0204	1	< 0.1%
0.021	1	< 0.1%
0.022	1	< 0.1%
0.0222	1	< 0.1%
0.0223	1	< 0.1%
0.0227	1	< 0.1%
0.0246	1	< 0.1%

Value	Count	Frequency (%)
0.997	1	< 0.1%
0.996	2	< 0.1%
0.995	4	< 0.1%
0.994	5	< 0.1%
0.993	6	< 0.1%
0.992	1	< 0.1%
0.991	7	< 0.1%
0.99	1	< 0.1%
0.989	5	< 0.1%
0.988	6	< 0.1%

key
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	5.231578515

Minimum	0
Maximum	11
Zeros	3035
Zeros (%)	10.3%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.560265626
Coefficient of variation (CV)	0.6805337273
Kurtosis	-1.29054339
Mean	5.231578515
Median Absolute Deviation (MAD)	3
Skewness	0.00151409637
Sum	127300
Variance	12.67549133
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	3035	10.3%
7	2851	9.7%
2	2502	8.5%
9	2448	8.3%
5	2183	7.4%
1	2181	7.4%
4	1885	6.4%
10	1773	6.0%
11	1702	5.8%
8	1519	5.1%
Other values (2)	2254	7.6%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3035	10.3%
1	2181	7.4%
2	2502	8.5%
3	819	2.8%
4	1885	6.4%
5	2183	7.4%
6	1435	4.9%
7	2851	9.7%
8	1519	5.1%
9	2448	8.3%

Value	Count	Frequency (%)
11	1702	5.8%
10	1773	6.0%
9	2448	8.3%
8	1519	5.1%
7	2851	9.7%
6	1435	4.9%
5	2183	7.4%
4	1885	6.4%
3	819	2.8%
2	2502	8.5%

loudness
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	11165
Distinct (%)	45.9%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	-8.664383759

Minimum	-28.03
Maximum	2.291
Zeros	0
Zeros (%)	0.0%
Negative	24331
Negative (%)	82.5%
Memory size	230.6 KiB

Quantile statistics

Minimum	-28.03
5-th percentile	-15.0694
Q1	-11.034
median	-8.205
Q3	-5.856
95-th percentile	-3.703
Maximum	2.291
Range	30.321
Interquartile range (IQR)	5.178

Descriptive statistics

Standard deviation	3.6010244
Coefficient of variation (CV)	-0.4156122928
Kurtosis	0.3478938965
Mean	-8.664383759
Median Absolute Deviation (MAD)	2.538
Skewness	-0.6489054219
Sum	-210830.45
Variance	12.96737673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5.318	10	< 0.1%
-9.088	10	< 0.1%
-7.076	10	< 0.1%
-5.18	10	< 0.1%
-5.987	9	< 0.1%
-8.749	9	< 0.1%
-5.076	9	< 0.1%
-5.79	9	< 0.1%
-6.836	9	< 0.1%
-9.903	8	< 0.1%
Other values (11155)	24240	82.2%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-28.03	1	< 0.1%
-27.861	1	< 0.1%
-27.119	1	< 0.1%
-27.01	1	< 0.1%
-26.826	1	< 0.1%
-26.549	1	< 0.1%
-26.149	1	< 0.1%
-25.487	1	< 0.1%
-25.473	1	< 0.1%
-25.035	1	< 0.1%

Value	Count	Frequency (%)
2.291	1	< 0.1%
0.175	1	< 0.1%
-0.463	1	< 0.1%
-0.507	1	< 0.1%
-0.517	1	< 0.1%
-0.698	1	< 0.1%
-0.81	1	< 0.1%
-0.883	1	< 0.1%
-0.884	1	< 0.1%
-0.945	1	< 0.1%

mode
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	5167
Missing (%)	17.5%
Memory size	230.6 KiB

True	17694
False	6639
(Missing)	5167

Common Values
Chart

Value	Count	Frequency (%)
True	17694	60.0%
False	6639	22.5%
(Missing)	5167	17.5%

speechiness
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	1230
Distinct (%)	5.1%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.07355550076

Minimum	0
Maximum	0.951
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.027
Q1	0.0321
median	0.0413
Q3	0.0683
95-th percentile	0.268
Maximum	0.951
Range	0.951
Interquartile range (IQR)	0.0362

Descriptive statistics

Standard deviation	0.08315419853
Coefficient of variation (CV)	1.130495988
Kurtosis	12.4944506
Mean	0.07355550076
Median Absolute Deviation (MAD)	0.0116
Skewness	3.161316737
Sum	1789.826
Variance	0.006914620733
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0295	118	0.4%
0.0287	116	0.4%
0.0303	115	0.4%
0.0299	114	0.4%
0.0294	113	0.4%
0.0317	112	0.4%
0.029	111	0.4%
0.0306	110	0.4%
0.0319	110	0.4%
0.0293	109	0.4%
Other values (1220)	23205	78.7%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.022	1	< 0.1%
0.0221	1	< 0.1%
0.0224	5	< 0.1%
0.0225	3	< 0.1%
0.0226	1	< 0.1%
0.0227	2	< 0.1%
0.0228	5	< 0.1%
0.0229	3	< 0.1%
0.023	4	< 0.1%

Value	Count	Frequency (%)
0.951	1	< 0.1%
0.924	1	< 0.1%
0.913	1	< 0.1%
0.894	1	< 0.1%
0.888	1	< 0.1%
0.858	1	< 0.1%
0.855	1	< 0.1%
0.847	1	< 0.1%
0.846	2	< 0.1%
0.74	1	< 0.1%

acousticness
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3057
Distinct (%)	12.6%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.2946368962

Minimum	2.51 × 10^-6
Maximum	0.991
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	2.51 × 10^-6
5-th percentile	0.00265
Q1	0.0467
median	0.195
Q3	0.508
95-th percentile	0.839
Maximum	0.991
Range	0.99099749
Interquartile range (IQR)	0.4613

Descriptive statistics

Standard deviation	0.2823054681
Coefficient of variation (CV)	0.9581470337
Kurtosis	-0.7204904632
Mean	0.2946368962
Median Absolute Deviation (MAD)	0.1748
Skewness	0.7615593299
Sum	7169.399595
Variance	0.07969637731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.117	50	0.2%
0.111	48	0.2%
0.113	47	0.2%
0.107	47	0.2%
0.101	47	0.2%
0.13	45	0.2%
0.114	45	0.2%
0.105	45	0.2%
0.104	44	0.1%
0.108	44	0.1%
Other values (3047)	23871	80.9%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.51 × 10^-6	1	< 0.1%
3.28 × 10^-6	1	< 0.1%
3.29 × 10^-6	1	< 0.1%
5.67 × 10^-6	1	< 0.1%
7.81 × 10^-6	1	< 0.1%
8 × 10^-6	1	< 0.1%
9.4 × 10^-6	1	< 0.1%
9.44 × 10^-6	1	< 0.1%
1.21 × 10^-5	2	< 0.1%
1.24 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
0.991	1	< 0.1%
0.99	2	< 0.1%
0.989	1	< 0.1%
0.988	4	< 0.1%
0.987	5	< 0.1%
0.986	1	< 0.1%
0.985	1	< 0.1%
0.983	2	< 0.1%
0.982	2	< 0.1%
0.981	3	< 0.1%

instrumentalness
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	4423
Distinct (%)	18.2%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.03254034614

Minimum	0
Maximum	0.982
Zeros	10079
Zeros (%)	34.2%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4.53 × 10^-6
Q3	0.00046
95-th percentile	0.1694
Maximum	0.982
Range	0.982
Interquartile range (IQR)	0.00046

Descriptive statistics

Standard deviation	0.1362787863
Coefficient of variation (CV)	4.187994366
Kurtosis	25.58618698
Mean	0.03254034614
Median Absolute Deviation (MAD)	4.53 × 10^-6
Skewness	5.040325148
Sum	791.8042427
Variance	0.0185719076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10079	34.2%
1.16 × 10^-6	25	0.1%
1.03 × 10^-5	25	0.1%
1.17 × 10^-6	19	0.1%
1.2 × 10^-6	19	0.1%
1.19 × 10^-6	18	0.1%
1.23 × 10^-5	18	0.1%
0.000104	18	0.1%
1.19 × 10^-5	18	0.1%
1.05 × 10^-5	18	0.1%
Other values (4413)	14076	47.7%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10079	34.2%
1 × 10^-6	4	< 0.1%
1.01 × 10^-6	17	0.1%
1.02 × 10^-6	14	< 0.1%
1.03 × 10^-6	15	0.1%
1.04 × 10^-6	12	< 0.1%
1.05 × 10^-6	12	< 0.1%
1.06 × 10^-6	6	< 0.1%
1.07 × 10^-6	10	< 0.1%
1.08 × 10^-6	14	< 0.1%

Value	Count	Frequency (%)
0.982	2	< 0.1%
0.981	1	< 0.1%
0.978	1	< 0.1%
0.966	2	< 0.1%
0.965	2	< 0.1%
0.963	3	< 0.1%
0.962	2	< 0.1%
0.961	2	< 0.1%
0.96	1	< 0.1%
0.959	1	< 0.1%

liveness
Real number (ℝ_≥0)

MISSING

Distinct	1611
Distinct (%)	6.6%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.1921024152

Minimum	0.00967
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0.00967
5-th percentile	0.0521
Q1	0.0909
median	0.131
Q3	0.249
95-th percentile	0.533
Maximum	0.999
Range	0.98933
Interquartile range (IQR)	0.1581

Descriptive statistics

Standard deviation	0.1590751067
Coefficient of variation (CV)	0.8280744753
Kurtosis	5.183101997
Mean	0.1921024152
Median Absolute Deviation (MAD)	0.0558
Skewness	2.104279463
Sum	4674.42807
Variance	0.02530488957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.106	202	0.7%
0.111	200	0.7%
0.107	197	0.7%
0.108	189	0.6%
0.11	185	0.6%
0.105	183	0.6%
0.114	180	0.6%
0.109	179	0.6%
0.112	176	0.6%
0.104	175	0.6%
Other values (1601)	22467	76.2%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.00967	1	< 0.1%
0.013	1	< 0.1%
0.0136	2	< 0.1%
0.0145	1	< 0.1%
0.0146	1	< 0.1%
0.0166	1	< 0.1%
0.0169	1	< 0.1%
0.0184	1	< 0.1%
0.0186	1	< 0.1%
0.0189	1	< 0.1%

Value	Count	Frequency (%)
0.999	1	< 0.1%
0.997	1	< 0.1%
0.991	1	< 0.1%
0.99	2	< 0.1%
0.989	2	< 0.1%
0.988	2	< 0.1%
0.987	1	< 0.1%
0.986	1	< 0.1%
0.984	2	< 0.1%
0.982	1	< 0.1%

valence
Real number (ℝ_≥0)

MISSING

Distinct	1103
Distinct (%)	4.5%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.6017609789

Minimum	0
Maximum	0.991
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.189
Q1	0.415
median	0.622
Q3	0.802
95-th percentile	0.955
Maximum	0.991
Range	0.991
Interquartile range (IQR)	0.387

Descriptive statistics

Standard deviation	0.2386377227
Coefficient of variation (CV)	0.3965656316
Kurtosis	-0.940241214
Mean	0.6017609789
Median Absolute Deviation (MAD)	0.192
Skewness	-0.2711212212
Sum	14642.6499
Variance	0.05694796268
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	136	0.5%
0.962	118	0.4%
0.963	118	0.4%
0.964	100	0.3%
0.965	91	0.3%
0.96	83	0.3%
0.966	71	0.2%
0.969	58	0.2%
0.967	57	0.2%
0.926	56	0.2%
Other values (1093)	23445	79.5%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.0349	1	< 0.1%
0.0352	1	< 0.1%
0.0359	1	< 0.1%
0.0361	1	< 0.1%
0.0363	1	< 0.1%
0.0364	1	< 0.1%
0.0371	2	< 0.1%
0.0373	1	< 0.1%
0.0376	1	< 0.1%

Value	Count	Frequency (%)
0.991	1	< 0.1%
0.99	1	< 0.1%
0.989	1	< 0.1%
0.988	1	< 0.1%
0.987	1	< 0.1%
0.986	1	< 0.1%
0.985	3	< 0.1%
0.984	1	< 0.1%
0.983	2	< 0.1%
0.982	2	< 0.1%

tempo
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	20484
Distinct (%)	84.2%
Missing	5167
Missing (%)	17.5%
Infinite	0
Infinite (%)	0.0%
Mean	120.2775407

Minimum	0
Maximum	241.009
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	230.6 KiB

Quantile statistics

Minimum	0
5-th percentile	79.1556
Q1	99.063
median	118.913
Q3	136.484
95-th percentile	173.828
Maximum	241.009
Range	241.009
Interquartile range (IQR)	37.421

Descriptive statistics

Standard deviation	28.04656978
Coefficient of variation (CV)	0.2331821021
Kurtosis	0.01721647799
Mean	120.2775407
Median Absolute Deviation (MAD)	18.926
Skewness	0.5138985749
Sum	2926713.398
Variance	786.6100765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
119.987	8	< 0.1%
119.991	7	< 0.1%
113	6	< 0.1%
125.008	6	< 0.1%
120.08	6	< 0.1%
119.999	6	< 0.1%
99.991	6	< 0.1%
116	6	< 0.1%
140.022	6	< 0.1%
128.002	6	< 0.1%
Other values (20474)	24270	82.3%
(Missing)	5167	17.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
35.716	1	< 0.1%
36.71	1	< 0.1%
37.114	1	< 0.1%
47.94	1	< 0.1%
48.718	1	< 0.1%
50.937	1	< 0.1%
51.391	1	< 0.1%
51.409	1	< 0.1%
53.919	1	< 0.1%

Value	Count	Frequency (%)
241.009	1	< 0.1%
233.429	1	< 0.1%
216.2	1	< 0.1%
213.737	1	< 0.1%
211.261	1	< 0.1%
211.206	1	< 0.1%
210.874	1	< 0.1%
210.75	1	< 0.1%
210.186	1	< 0.1%
209.819	1	< 0.1%

time_signature
Categorical

HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	5167
Missing (%)	17.5%
Memory size	230.6 KiB

4.0	22489
3.0	1564
5.0	186
1.0	92
0.0	2

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	72999
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.0
2nd row	3.0
3rd row	4.0
4th row	4.0
5th row	4.0

Common Values

Value	Count	Frequency (%)
4.0	22489	76.2%
3.0	1564	5.3%
5.0	186	0.6%
1.0	92	0.3%
0.0	2	< 0.1%
(Missing)	5167	17.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
4.0	22489	92.4%
3.0	1564	6.4%
5.0	186	0.8%
1.0	92	0.4%
0.0	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	24335	33.3%
.	24333	33.3%
4	22489	30.8%
3	1564	2.1%
5	186	0.3%
1	92	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	48666	66.7%
Other Punctuation	24333	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24335	50.0%
4	22489	46.2%
3	1564	3.2%
5	186	0.4%
1	92	0.2%

Other Punctuation

Value	Count	Frequency (%)
.	24333	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	72999	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24335	33.3%
.	24333	33.3%
4	22489	30.8%
3	1564	2.1%
5	186	0.3%
1	92	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72999	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24335	33.3%
.	24333	33.3%
4	22489	30.8%
3	1564	2.1%
5	186	0.3%
1	92	0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	weekid	week_position	song	performer	weeks_on_chart	peak_position	spotify_track_duration_ms	spotify_track_explicit	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature
0	2009-12-26	51	My Life Would Suck Without You	Glee Cast	1	51	211800.0	False	0.471	0.663	9.0	-6.284	True	0.0348	0.01770	0.000000	0.0801	0.449	145.078	4.0
1	2014-01-04	51	I Have Nothing	Tessanne Chin	1	51	231141.0	False	0.398	0.639	9.0	-3.517	False	0.0338	0.23500	0.000000	0.0972	0.197	154.247	3.0
2	2017-07-29	51	Family Feud	JAY-Z Featuring Beyonce	1	51	251413.0	True	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	2018-12-22	51	I Don't Let Go	XXXTENTACION	1	51	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	2019-06-01	51	I Think	Tyler, The Creator	1	51	212013.0	True	0.826	0.579	8.0	-8.241	False	0.0801	0.00881	0.000000	0.1290	0.431	121.075	4.0
5	2019-09-07	51	I Think He Knows	Taylor Swift	1	51	173386.0	False	0.897	0.366	0.0	-8.029	True	0.0569	0.00889	0.000353	0.0715	0.416	100.003	4.0
6	2020-05-16	51	Losses	Drake	1	51	271183.0	True	0.551	0.570	1.0	-7.385	False	0.3510	0.28000	0.000000	0.4240	0.505	85.687	4.0
7	2010-10-16	52	I'm A Slave 4 U	Glee Cast	1	52	204053.0	False	0.909	0.779	0.0	-4.004	False	0.1360	0.40900	0.000681	0.0398	0.955	110.022	4.0
8	2011-04-02	52	Misery	Glee Cast	1	52	188800.0	False	0.749	0.631	7.0	-5.826	True	0.0569	0.18800	0.000000	0.1100	0.812	102.962	4.0
9	2011-09-17	52	MegaMan	Lil Wayne	1	52	198280.0	True	0.504	0.856	11.0	-5.024	False	0.2860	0.01140	0.000000	0.2560	0.335	101.866	5.0

Last rows

	weekid	week_position	song	performer	weeks_on_chart	peak_position	spotify_track_duration_ms	spotify_track_explicit	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature
29490	1962-07-28	77	Sweet And Lovely	April Stevens & Nino Tempo	4	77	175533.0	False	0.669	0.515	10.0	-11.804	True	0.0396	0.617	0.0	0.3060	0.865	121.928	4.0
29491	1963-01-26	77	Darkest Street In Town	Jimmy Clanton	4	77	139760.0	False	0.502	0.832	5.0	-7.354	False	0.0394	0.417	0.0	0.0897	0.975	147.778	4.0
29492	1966-07-23	77	Ain't Gonna Cry No More	Brenda Lee	4	77	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29493	1977-12-03	77	Still The Lovin' Is Fun	B.J. Thomas	4	77	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29494	1964-04-11	78	Roll Over Beethoven	The Beatles	4	68	165466.0	False	0.351	0.749	2.0	-9.435	True	0.0628	0.289	0.0	0.0952	0.967	160.673	4.0
29495	1959-03-14	78	Bunny Hop	The Applejacks	4	70	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29496	1967-03-11	78	Peek-A-Boo	The New Vaudeville Band	4	72	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29497	1964-01-25	78	Do-Wah-Diddy	The Exciters	4	78	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
29498	1965-08-28	78	Summer Wind	Wayne Newton	4	78	157760.0	False	0.469	0.327	6.0	-15.184	True	0.0343	0.432	0.0	0.2690	0.556	114.647	4.0
29499	1968-10-19	78	Oh Lord, Why Lord	Los Pop Tops	4	78	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Most frequently occurring

	weekid	week_position	song	performer	weeks_on_chart	peak_position	spotify_track_duration_ms	spotify_track_explicit	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	time_signature	# duplicates
0	2019-06-29	45	When The Party's Over	Billie Eilish	32	29	196077.0	False	0.367	0.111	4.0	-14.084	True	0.0972	0.97800	0.000040	0.0897	0.198	82.642	4.0	2
1	2019-06-29	47	Envy Me	Calboy	27	31	120133.0	True	0.740	0.488	1.0	-7.664	False	0.2700	0.23400	0.000000	0.2410	0.584	149.042	4.0	2
2	2019-06-29	70	Miss Me More	Kelsea Ballerini	20	47	192840.0	False	0.643	0.720	2.0	-7.146	True	0.0527	0.01400	0.000000	0.0834	0.491	96.028	4.0	2
3	2019-06-29	99	Racks In The Middle	Nipsey Hussle Featuring Roddy Ricch & Hit-Boy	11	99	233277.0	True	0.671	0.833	5.0	-5.152	False	0.3950	0.08250	0.000000	0.0726	0.702	79.351	4.0	2
4	2019-07-06	87	Here With Me	Marshmello Featuring CHVRCHES	16	31	156346.0	False	0.791	0.565	5.0	-3.933	False	0.0439	0.06230	0.000000	0.1560	0.181	99.961	4.0	2
5	2019-07-06	88	Love Someone	Brett Eldredge	10	52	211720.0	False	0.423	0.813	9.0	-5.011	True	0.0507	0.21800	0.000002	0.0732	0.421	173.995	4.0	2
6	2019-07-06	94	Big Ole Freak	Megan Thee Stallion	12	65	214850.0	True	0.799	0.699	2.0	-7.694	True	0.2040	0.00867	0.000000	0.1320	0.627	142.979	4.0	2
7	2019-07-06	96	You Stay	DJ Khaled Featuring Meek Mill, J Balvin, Lil Baby & Jeremih	4	96	275275.0	True	0.479	0.630	7.0	-5.628	False	0.1330	0.03140	0.000000	0.0730	0.227	117.988	5.0	2
8	2019-07-13	71	Homicide	Logic Featuring Eminem	6	71	245386.0	True	0.694	0.759	10.0	-5.667	False	0.3980	0.13700	0.000000	0.1670	0.770	140.055	4.0	2
9	2019-07-13	88	Eyes On You	Chase Rice	20	38	182493.0	False	0.606	0.652	9.0	-6.982	True	0.0281	0.32300	0.000000	0.2010	0.476	97.155	4.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Open Punctuation

Close Punctuation

Space Separator

Dash Punctuation

Currency Symbol

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Latin 1 Sup

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Open Punctuation

Close Punctuation

Space Separator

Dash Punctuation

Currency Symbol

Math Symbol

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ